SetConditionalFormatting(Int32,Int32,Int32,Int32,Boolean,IConditionalFormattingRule[]) Method
In This Topic
Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
Syntax
'Declaration
Public Overloads Sub SetConditionalFormatting( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As Boolean, _
ByVal ParamArray () As IConditionalFormattingRule _
)
'Usage
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim isCombinable As Boolean
Dim rules() As IConditionalFormattingRule
instance.SetConditionalFormatting(row, column, rowCount, columnCount, isCombinable, rules)
public void SetConditionalFormatting(
int ,
int column,
int ,
int columnCount,
bool ,
params IConditionalFormattingRule[]
)
Parameters
- row
- Starting row index
- column
- Starting column index
- rowCount
- Number of rows
- columnCount
- Number of columns
- isCombinable
- Indicates that rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
- rules
- Rules to apply for the specified range of cells
See Also